The Best Practices section contains built-in reports that help SQL Server administrators check whether their SQL Server environment has b
image, or clone or instance, and so does not need to be assigned to a team. The two developers, Mo and Ben, are members of a Common team,
image, or clone or instance, and so does not need to be assigned to a team. The two developers, Mo and Ben, are members of a Common team,
;database=SomeTargetDatabase;Uid=sa;Pwd=123;TrustServerCertificate=true" --rows-to-generate 1000 # Using a PostgreSQL local database using
/testdatamanager/command-line-interface-cli/data-generation/data-generation-command-line-reference
the 6.11 release we no longer support .mdb databases. If you prefer not to use SQL Server database, you can use SQLite database file inst
the 6.11 release we no longer support .mdb databases. If you prefer not to use SQL Server database, you can use SQLite database file inst
that some functionality may be limited and will be extended in upcoming releases. Fixes SA-2104: Type forwarding attributes are now prese
/sa6/release-notes-and-other-versions/smartassembly-6-13-release-notes
that some functionality may be limited and will be extended in upcoming releases. Fixes SA-2104: Type forwarding attributes are now prese
/sa8/release-notes-and-other-versions/smartassembly-6-13-release-notes
that some functionality may be limited and will be extended in upcoming releases. Fixes SA-2104: Type forwarding attributes are now prese
/sa7/release-notes-and-other-versions/smartassembly-6-13-release-notes
BP012Best practice rules Adhere to good industry practices. BP001 – Index type is not specified The index type (whether it is CLUSTERED o
1000 statements in a migration, and your communication overhead is 0.1 second. Without batching the migrate process would have a 1000 x 0
the database owner In this example, we check the database owner, then set it to the built-in sa account if it is set to another value. In
the changes & drift reports Default Whatever is set as your 'flyway.user' Usage Commandline ./flyway check -changes -url="jdbc://url1" -c
be run concurrently. 8.1.2 - October 6th, 2022 Improvements SA-2492: Extended scope of key size limitation for .snk files. Previously val
/sa8/release-notes-and-other-versions/smartassembly-8-0-release-notes
Fixes: SCA-2654: You can now generate migrations with over 1000 changes and baseline from databases with more than 1000 programmable obje
If you used SmartAssembly 6 and now upgrading to SmartAssembly 7, please be aware of a couple breaking changes. Please follow the instruc
If you used SmartAssembly 7 and now upgrading to SmartAssembly 8, please be aware of a couple breaking changes. Please follow the instruc
If you used SmartAssembly 6 and now upgrading to SmartAssembly 7, please be aware of a couple breaking changes. Please follow the instruc
. In this example, there are two databases in our SQL Server instance: foobar (the target) and check_build_db. Both can be accessed by the
/fd/tutorial-using-flyway-check-with-sql-server-184127628.html
IMPORTANT - If you update an issue title and/or description, please inform the SQL Prompt dev team (as we need to keep what is displayed
/codeanalysis/code-analysis-for-sql-server/best-practice-rules
the rules; we've changed the default commit frequency from 1000 to 100,000 rows. In our testing, this produces the best performance. This
the following two secrets in Dapr: secret1 which contains flyway.url=jdbc:h2:mem:db secret2 which contains flyway.user=sa In order to rea
; We've changed the default commit frequency from 1000 to 100,000 rows; in our testing, this produces the best performance. This option is
/dms6/data-masker-help/version-6-tech-tips/v7-enhanced-performance-beta
7.4.6 - August 20th, 2020 FREQUENT UPDATES RELEASE Fixes SA-2248: Default interface methods (C# 8.0) are no longer pruned in certain scen
/sa8/release-notes-and-other-versions/smartassembly-7-4-release-notes
7.4.6 - August 20th, 2020 FREQUENT UPDATES RELEASE Fixes SA-2248: Default interface methods (C# 8.0) are no longer pruned in certain scen
/sa7/release-notes-and-other-versions/smartassembly-7-4-release-notes